package com.woniuxy.main.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Select;

import com.woniuxy.main.pojo.Vi_user_coach;
import com.woniuxy.main.pojo.Vi_user_student;

public interface Vi_user_coachMapper {
	
	// 查询所有
	@Select("select * from vi_user_coach")
	public List<Vi_user_coach> all();
	
	// 搜索教练
	public List<Vi_user_coach> searchCoach(Map<String,Object> map);
	
	//根据uid查询
	@Select("select * from vi_user_coach where uid=#{uid}")
	public Vi_user_coach selectByUid(int uid);
	
	//分页查询所有教练信息，一页显示8个
	@Select("select * from vi_user_coach order by uid limit #{page},8")
	public List<Vi_user_coach> showCoachList(int page);
		
	//查询总数
	@Select("select COUNT(*) from vi_user_coach")
	public int totalPage();


}
